home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vcuraccparts.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
596b
|
18 lines
/*
This view uses the context information. For each unique context combination, the total dollars from curacc and the count of records summed is given.
*/
CREATE OR REPLACE VIEW VCURACCPARTS AS SELECT distinct
MSTRREC.PROBE_CONTEXT,
MSTRREC.OPERATOR_CONTEXT,
MSTRREC.DRIVER_CONTEXT,
MSTRREC.FARE_CONTEXT,
count(MSTRREC.PROBE_CONTEXT) pcount,
sum(curacc.currency_val) * 0.01 pdollars
FROM
MSTRREC ,curacc
where curacc.det_seq_num = mstrrec.det_seq_num
group by MSTRREC.PROBE_CONTEXT,
MSTRREC.OPERATOR_CONTEXT,
MSTRREC.DRIVER_CONTEXT,
MSTRREC.FARE_CONTEXT;